IF OBJECT_ID('dbo.csp_rptMetric_AwardsActivated') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.csp_rptMetric_AwardsActivated
END
GO

CREATE PROCEDURE dbo.csp_rptMetric_AwardsActivated
(
	@PeriodType varchar(50)
,	@PeriodStartDate smalldatetime
,	@Institution varchar(50)
)
AS

SELECT 
	* 
FROM 
	rptMetric_AwardActivations
WHERE 
	PeriodStartDate = @PeriodStartDate
AND	PeriodType=@PeriodType
AND	(Institution = @Institution OR @Institution IS NULL)

GO
